from bokeh.io import output_notebook, output_file
from bokeh.plotting import show, figure
from bokeh.layouts import gridplot, column
from bokeh.models import HoverTool, ColumnDataSource, Jitter, Label, Span, LinearInterpolator, CategoricalColorMapper
from bokeh.models.widgets import Panel, Tabs, Div
from datetime import datetime as dt
import time
import numpy as np
import pandas as pd
from pandas.io import gbq
projectId = 'mindful-carport-156107'
output_notebook()
h = 400
w = 1200
bbSmall = 5
bbBig = 50
legendCat1 = '6pt'
legendCity = '6pt'
legendSource = '8pt'
startDate = '2017-03-01'
tvcDate1 = time.mktime(dt(2017, 5, 12, 2, 0, 0).timetuple())*1000
tvcDate = time.mktime(dt(2017, 9, 21, 2, 0, 0).timetuple())*1000
tvcDate2 = time.mktime(dt(2017, 11, 13, 2, 0, 0).timetuple())*1000
eurekaDate = time.mktime(dt(2017, 10, 6, 2, 0, 0).timetuple())*1000
hash = {}
c = ('aliceblue', 'antiquewhite', 'aqua', 'aquamarine', 'azure', 'beige', 'bisque', 'black',
'blanchedalmond', 'blue', 'blueviolet', 'brown', 'burlywood', 'cadetblue', 'chartreuse',
'chocolate', 'coral', 'cornflowerblue', 'cornsilk', 'crimson', 'cyan', 'darkblue', 'darkcyan',
'darkgoldenrod', 'darkgray', 'darkgreen', 'darkgrey', 'darkkhaki', 'darkmagenta', 'darkolivegreen',
'darkorange', 'darkorchid', 'darkred', 'darksalmon', 'darkseagreen', 'darkslateblue', 'darkslategray',
'darkslategrey', 'darkturquoise', 'darkviolet', 'deeppink', 'deepskyblue', 'dimgray', 'dimgrey', 'dodgerblue',
'firebrick', 'floralwhite', 'forestgreen', 'fuchsia', 'gainsboro', 'ghostwhite', 'gold', 'goldenrod',
'gray', 'green', 'greenyellow', 'grey', 'honeydew', 'hotpink', 'indianred', 'indigo', 'ivory', 'khaki',
'lavender', 'lavenderblush', 'lawngreen', 'lemonchiffon', 'lightblue', 'lightcoral', 'lightcyan',
'lightgoldenrodyellow', 'lightgray', 'lightgreen', 'lightgrey', 'lightpink', 'lightsalmon', 'lightseagreen',
'lightskyblue', 'lightslategray', 'lightslategrey', 'lightsteelblue', 'lightyellow', 'lime', 'limegreen',
'linen', 'magenta', 'maroon', 'mediumaquamarine', 'mediumblue', 'mediumorchid', 'mediumpurple', 'mediumseagreen',
'mediumslateblue', 'mediumspringgreen', 'mediumturquoise', 'mediumvioletred', 'midnightblue', 'mintcream', 'mistyrose',
'moccasin', 'navajowhite', 'navy', 'oldlace', 'olive', 'olivedrab', 'orange', 'orangered', 'orchid', 'palegoldenrod',
'palegreen', 'paleturquoise', 'palevioletred', 'papayawhip', 'peachpuff', 'peru', 'pink', 'plum', 'powderblue',
'purple', 'red', 'rosybrown', 'royalblue', 'saddlebrown', 'salmon', 'sandybrown', 'seagreen', 'seashell', 'sienna',
'silver', 'skyblue', 'slateblue', 'slategray', 'slategrey', 'snow', 'springgreen', 'steelblue', 'tan', 'teal',
'thistle', 'tomato', 'turquoise', 'violet', 'wheat', 'white', 'whitesmoke', 'yellow', 'yellowgreen');
# Holoviews plot
import holoviews as hv
from pandas.io import gbq
hv.extension('bokeh')
h = 600
w = 1500
from plotly import tools
import plotly.graph_objs as go
import plotly as py
from plotly.graph_objs import Scatter, Layout
py.offline.init_notebook_mode()
import cufflinks as cf
cf.set_config_file(offline=True, world_readable=False, theme='pearl')
import plotly.figure_factory as ff